package com.icim.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import javax.annotation.Resource;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Repository;

import com.icim.entity.His_ret_prd_in;
import com.icim.entity.Ret_prd_in_twqc;

@Repository
public class RetPrdInTwqcDao {
	
	 @Resource
	 private JdbcTemplate icimJdbcTemplate;

	 public void save(Ret_prd_in_twqc prd_in) {
	        String sql ="INSERT INTO RET_PRD_IN_TWQC VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,"
	        		+ "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,"
	        		+ "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,"
	        		+ "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

	        icimJdbcTemplate.update(sql,new Object[] { prd_in.getDELIVERY_NO(),prd_in.getFACTORYID(),prd_in.getSHIPPINGFROM(),
	        		prd_in.getSHIPPINGTO(),prd_in.getSHIPPINGDATE(),prd_in.getPALLET_ID(),prd_in.getCARTON_ID(),
	        		prd_in.getFORCE_EMPTY(),prd_in.getPRODUCTID(),prd_in.getPANEL_MODE(),prd_in.getPPBOX_GRADE(),
	        		prd_in.getGLASS_QTY(),prd_in.getERCODE(),prd_in.getERMESSAGE(),prd_in.getGSFLAG(),prd_in.getCT1FLAG(),
	        		prd_in.getCHIP_QTY(),prd_in.getPPBOX_COUNT(),prd_in.getGLASS_TYPE(),prd_in.getPE_PRODUCT_ID(),
	        		prd_in.getREJECT_REASON_CODE(),prd_in.getRETURN_COMMENT(),prd_in.getPALLET_OWNER(),prd_in.getPALLET_TYPE(),
	        		prd_in.getPALLET_ZONE_CODE(),prd_in.getPALLET_SET_CODE(),prd_in.getPP_BOX_ZONE_CODE(),
	        		prd_in.getPP_BOX_SETTING_CODE(),prd_in.getCONTAINER_NO(),prd_in.getFACTORYID_TO(),prd_in.getBOX_PN(),
	        		prd_in.getGLASSID(),prd_in.getMES_SHIP_DATE(),prd_in.getSLOT_NO(),prd_in.getORIGINALPRODUCT(),
	        		prd_in.getORIGINALPLAN(),prd_in.getORIGINALCELPARTNO(),prd_in.getORIGINALLOTID(),prd_in.getORIGINALLOTTYPE(),
	        		prd_in.getORIGINALBATCH(),prd_in.getORIGINALSIZE(),prd_in.getOXDATA(),prd_in.getARRAYTESTREASONCODE(),
	        		prd_in.getARRAYTESTTXNTIME(),prd_in.getCF_OX_INFO(),prd_in.getCFTESTREASONCODE(),prd_in.getCFTTESTTXNTIME(),
	        		prd_in.getASMTESTDATA(),prd_in.getASMTESTREASONCODE(),prd_in.getASMTESTTXNTIME(),prd_in.getCT1DATA(),
	        		prd_in.getCT1REASON(),prd_in.getCT1TESTTXNTIME(),prd_in.getCT2DATA(),prd_in.getCT2REASON(),
	        		prd_in.getCT2TESTTXNTIME(),prd_in.getCELL_REPAIR_FLAG(),prd_in.getENGINEERING(),prd_in.getOXDEFECODE(),
	        		prd_in.getQUADRANT(),prd_in.getOXFLAG(),prd_in.getOXGRADE(),prd_in.getOXLEVEL(),prd_in.getOWNER(),
	        		prd_in.getX(),prd_in.getY(),prd_in.getTFT_REPAIR_FLAG(),prd_in.getTWO_CUT_DATE_TIME(),prd_in.getEXP_NO(),
	        		prd_in.getLASER_SHORT_RING_CUT(),prd_in.getRGB_DROP_HEIGHT(),prd_in.getPS_HEIGHT(),prd_in.getODF_PULSE(),
	        		prd_in.getSHEET_JUDGE(),prd_in.getTFT_DEFECT_CODE(),prd_in.getTFT_DEFECT_X(),prd_in.getTFT_DEFECT_Y(),
	        		prd_in.getCF_DEFECT_CODE(),prd_in.getCF_DEFECT_X(),prd_in.getCF_DEFECT_Y(),prd_in.getCF_POSITION(),
	        		prd_in.getLCD_PACK_TIME(),prd_in.getCF_GLASS_ID(),prd_in.getTFT_POLARIZER(),prd_in.getCF_POLARIZER(),
	        		prd_in.getGOOD_CUT_COUNT(),prd_in.getCUT_OX_INFO(),prd_in.getUPDFLAG(),prd_in.getUPDUSER(),
	        		prd_in.getUPDTIME(),prd_in.getINPUT_STATUS(),prd_in.getLC_DROPPED(),prd_in.getABNORMAL_TFT(),
	        		prd_in.getABNORMAL_CF(),prd_in.getABNORMAL_LCD(),prd_in.getGOOD_CHIP_COUNT(),prd_in.getTWO_CUTTING_DATE_TIME(),
	        		prd_in.getQ_DATE_TIME(),prd_in.getQ_TIME_RESET_CNT(),prd_in.getLCD_PRODUCT_ID(),prd_in.getFORMAT_ID(),
	        		prd_in.getRISK_FLAG_CODE(),prd_in.getABNORMAL_LCM(),prd_in.getSERIAL_NO(),prd_in.getSERIAL_NO_CUST(),
	        		prd_in.getREVISION(),prd_in.getLCM_CARTON_GRADE(),prd_in.getLCM_GRADE(),prd_in.getDFCT_LIST(),
	        		prd_in.getWO_CUSTOMER(),prd_in.getFINAL_CUSTOMER(),prd_in.getAERB_NO(),prd_in.getPI_GROUP_ID(),
	        		prd_in.getPE_QTY(),prd_in.getSHIPPING_COUNT_TYPE(),prd_in.getGOOD_PNL_COUNT(),prd_in.getITO_FLAG(),
	        		prd_in.getTOD_GRADE(),prd_in.getCST_ID(),prd_in.getCST_ZONE_CODE(),prd_in.getCST_SETTING_CODE(),
	        		prd_in.getTFT_POSITION(),prd_in.getIN_STOCK_DATE(),prd_in.getCUT_FLAG(),prd_in.getSUBSTRATE_POSITION_ID(),
	        		prd_in.getCF_SUBSTRATE_POSITION_ID(),prd_in.getCUT_POSITION_ID(),prd_in.getCUT_CF_POSITION_ID(),
	        		prd_in.getPTT_GRADE(),prd_in.getTFT_STB_DATE(),prd_in.getTFT_STB_TIME(),prd_in.getLCD_EXP_NO(),
	        		prd_in.getLCD_ENG_NAME(),prd_in.getTFT_ABN_APPLY_TO(),prd_in.getCF_ABN_APPLY_TO(),prd_in.getLCD_ABN_APPLY_TO(),
	        		prd_in.getCF_STB_DATE(),prd_in.getCF_STB_TIME(),prd_in.getODF_MOVE_OUT_DATE_TIME(),prd_in.getCST_ABNORMAL_TFT(),
	        		prd_in.getCST_ABNORMAL_CF(),prd_in.getCST_ABNORMAL_LCD(),prd_in.getDEFECT_CODE(),prd_in.getRESET_2_CUT_DATE_TIME(),
	        		prd_in.getDN_ITEM(),prd_in.getGLASS_WITH_CHIP_ID(),prd_in.getPP_BOX_ID(),prd_in.getRISK_LOT_ID(),
	        		prd_in.getLC_PART_NO(),prd_in.getPROCESSED_GLASSID(),prd_in.getREF_DELIVERY_NO(),prd_in.getEVT_TIMESTAMP()});
	    }
	 
	 //得到所有的来料数据实体
	 public List<Ret_prd_in_twqc> getRetPrdInTwqcList()
	 {
		 String sql = "select * from ret_prd_in_twqc";
		 return icimJdbcTemplate.query(sql, new RowMapper<Ret_prd_in_twqc>() {
	          @Override
	          public Ret_prd_in_twqc mapRow(ResultSet rs, int rowNum) throws SQLException {
	        	  
	        	  return setEntityByRs(rs);
	          }
	      });
	 }
	 
	//根据历史表中查询出来的箱子id查询232客户的来料表
		 public List<Ret_prd_in_twqc> getRetPrdInListByBox(String boxId)
		 {
			 String sql = "select * from ret_prd_in_twqc where carton_id = '"+boxId+"' order by evt_timestamp desc";
			 return icimJdbcTemplate.query(sql, new RowMapper<Ret_prd_in_twqc>() {
		          @Override
		          public Ret_prd_in_twqc mapRow(ResultSet rs, int rowNum) throws SQLException {
		        	  
		        	  return setEntityByRs(rs);
		          }
		      });
		 }
		 //根据物理箱号和时间查询记录
		 public List<Ret_prd_in_twqc> getRetPrdInListByBoxAndTime(String boxId,String time)
		 {
			 String sql = "select * from ret_prd_in_twqc where carton_id = '"+boxId+"' and evt_timestamp ='"+time+"'";
			 return icimJdbcTemplate.query(sql, new RowMapper<Ret_prd_in_twqc>() {
		          @Override
		          public Ret_prd_in_twqc mapRow(ResultSet rs, int rowNum) throws SQLException {
		        	  
		        	  return setEntityByRs(rs);
		          }
		      });
		 }
		 
	public List<Ret_prd_in_twqc> getRetPrdInListByPId(String PId)
	{
		String sql = "select * from ret_prd_in_twqc where glassid='"+PId+"'";
		return icimJdbcTemplate.query(sql, new RowMapper<Ret_prd_in_twqc>() {
	          @Override
	          public Ret_prd_in_twqc mapRow(ResultSet rs, int rowNum) throws SQLException {
	        	  
	        	  return setEntityByRs(rs);
	          }
	      });
	}
		 
	 public Ret_prd_in_twqc setEntityByRs(ResultSet rs) throws SQLException
	 {
		 Ret_prd_in_twqc retPrdIn = new Ret_prd_in_twqc();
		 
		  retPrdIn.setDELIVERY_NO(rs.getString("DELIVERY_NO"));
	   	  retPrdIn.setFACTORYID(rs.getString("FACTORYID"));
	   	  retPrdIn.setSHIPPINGFROM(rs.getString("SHIPPINGFROM"));
	   	  retPrdIn.setSHIPPINGTO(rs.getString("SHIPPINGTO"));
	   	  retPrdIn.setSHIPPINGDATE(rs.getString("SHIPPINGDATE"));
	   	  retPrdIn.setPALLET_ID(rs.getString("PALLET_ID"));
	   	  retPrdIn.setCARTON_ID(rs.getString("CARTON_ID"));
	   	  retPrdIn.setFORCE_EMPTY(rs.getString("FORCE_EMPTY"));
	   	  retPrdIn.setPRODUCTID(rs.getString("PRODUCTID"));
	   	  retPrdIn.setPANEL_MODE(rs.getString("PANEL_MODE"));
	   	  retPrdIn.setPPBOX_GRADE(rs.getString("PPBOX_GRADE"));
	   	  retPrdIn.setGLASS_QTY(rs.getInt("GLASS_QTY"));
	   	  retPrdIn.setERCODE(rs.getString("ERCODE"));
	   	  retPrdIn.setERMESSAGE(rs.getString("ERMESSAGE"));
	   	  retPrdIn.setGSFLAG(rs.getString("GSFLAG"));
	   	  retPrdIn.setCT1FLAG(rs.getString("CT1FLAG"));
	   	  retPrdIn.setCHIP_QTY(rs.getInt("CHIP_QTY"));
	   	  retPrdIn.setPPBOX_COUNT(rs.getInt("PPBOX_COUNT"));
	   	  retPrdIn.setGLASS_TYPE(rs.getString("GLASS_TYPE"));
	   	  retPrdIn.setPE_PRODUCT_ID(rs.getString("PE_PRODUCT_ID"));
	   	  retPrdIn.setREJECT_REASON_CODE(rs.getString("REJECT_REASON_CODE"));
	   	  retPrdIn.setRETURN_COMMENT(rs.getString("RETURN_COMMENT"));
	   	  retPrdIn.setPALLET_OWNER(rs.getString("PALLET_OWNER"));
	   	  retPrdIn.setPALLET_TYPE(rs.getString("PALLET_TYPE"));
	   	  retPrdIn.setPALLET_ZONE_CODE(rs.getString("PALLET_ZONE_CODE"));
	   	  retPrdIn.setPALLET_SET_CODE(rs.getString("PALLET_SET_CODE"));
	   	  retPrdIn.setPP_BOX_ZONE_CODE(rs.getString("PP_BOX_ZONE_CODE"));
	   	  retPrdIn.setPP_BOX_SETTING_CODE(rs.getString("PP_BOX_SETTING_CODE"));
	   	  retPrdIn.setCONTAINER_NO(rs.getString("CONTAINER_NO"));
	   	  retPrdIn.setFACTORYID_TO(rs.getString("FACTORYID_TO"));
	   	  retPrdIn.setBOX_PN(rs.getString("BOX_PN"));
	   	  retPrdIn.setGLASSID(rs.getString("GLASSID"));
	   	  retPrdIn.setMES_SHIP_DATE(rs.getString("MES_SHIP_DATE"));
	   	  retPrdIn.setSLOT_NO(rs.getString("SLOT_NO"));
	   	  retPrdIn.setORIGINALPRODUCT(rs.getString("ORIGINALPRODUCT"));
	   	  retPrdIn.setORIGINALPLAN(rs.getString("ORIGINALPLAN"));
	   	  retPrdIn.setORIGINALCELPARTNO(rs.getString("ORIGINALCELPARTNO"));
	   	  retPrdIn.setORIGINALLOTID(rs.getString("ORIGINALLOTID"));
	   	  retPrdIn.setORIGINALLOTTYPE(rs.getString("ORIGINALLOTTYPE"));
	   	  retPrdIn.setORIGINALBATCH(rs.getString("ORIGINALBATCH"));
	   	  retPrdIn.setORIGINALSIZE(rs.getString("ORIGINALSIZE"));
	   	  retPrdIn.setOXDATA(rs.getString("OXDATA"));
	   	  retPrdIn.setARRAYTESTREASONCODE(rs.getString("ARRAYTESTREASONCODE"));
	   	  retPrdIn.setARRAYTESTTXNTIME(rs.getString("ARRAYTESTTXNTIME"));
	   	  retPrdIn.setCF_OX_INFO(rs.getString("CF_OX_INFO"));
	   	  retPrdIn.setCFTESTREASONCODE(rs.getString("CFTESTREASONCODE"));
	   	  retPrdIn.setCFTTESTTXNTIME(rs.getString("CFTTESTTXNTIME"));
	   	  retPrdIn.setASMTESTDATA(rs.getString("ASMTESTDATA"));
	   	  retPrdIn.setASMTESTREASONCODE(rs.getString("ASMTESTREASONCODE"));
	   	  retPrdIn.setASMTESTTXNTIME(rs.getString("ASMTESTTXNTIME"));
	   	  retPrdIn.setCT1DATA(rs.getString("CT1DATA"));
	   	  retPrdIn.setCT1REASON(rs.getString("CT1REASON"));
	   	  retPrdIn.setCT1TESTTXNTIME(rs.getString("CT1TESTTXNTIME"));
	   	  retPrdIn.setCT2DATA(rs.getString("CT2DATA"));
	   	  retPrdIn.setCT2REASON(rs.getString("CT2REASON"));
	   	  retPrdIn.setCT2TESTTXNTIME(rs.getString("CT2TESTTXNTIME"));
	   	  retPrdIn.setCELL_REPAIR_FLAG(rs.getString("CELL_REPAIR_FLAG"));
	   	  retPrdIn.setENGINEERING(rs.getString("ENGINEERING"));
	   	  retPrdIn.setOXDEFECODE(rs.getString("OXDEFECODE"));
	   	  retPrdIn.setQUADRANT(rs.getString("QUADRANT"));
	   	  retPrdIn.setOXFLAG(rs.getString("OXFLAG"));
	   	  retPrdIn.setOXGRADE(rs.getString("OXGRADE"));
	   	  retPrdIn.setOXLEVEL(rs.getString("OXLEVEL"));
	   	  retPrdIn.setOWNER(rs.getString("OWNER"));
	   	  retPrdIn.setX(rs.getInt("X"));
	   	  retPrdIn.setY(rs.getInt("Y"));
	   	  retPrdIn.setTFT_REPAIR_FLAG(rs.getString("TFT_REPAIR_FLAG"));
	   	  retPrdIn.setTWO_CUT_DATE_TIME(rs.getString("TWO_CUT_DATE_TIME"));
	   	  retPrdIn.setEXP_NO(rs.getString("EXP_NO"));
	   	  retPrdIn.setLASER_SHORT_RING_CUT(rs.getString("LASER_SHORT_RING_CUT"));
	   	  retPrdIn.setRGB_DROP_HEIGHT(rs.getString("RGB_DROP_HEIGHT"));
	   	  retPrdIn.setPS_HEIGHT(rs.getString("PS_HEIGHT"));
	   	  retPrdIn.setODF_PULSE(rs.getString("ODF_PULSE"));
	   	  retPrdIn.setSHEET_JUDGE(rs.getString("SHEET_JUDGE"));
	   	  retPrdIn.setTFT_DEFECT_CODE(rs.getString("TFT_DEFECT_CODE"));
	   	  retPrdIn.setTFT_DEFECT_X(rs.getString("TFT_DEFECT_X"));
	   	  retPrdIn.setTFT_DEFECT_Y(rs.getString("TFT_DEFECT_Y"));
	   	  retPrdIn.setCF_DEFECT_CODE(rs.getString("CF_DEFECT_CODE"));
	   	  retPrdIn.setCF_DEFECT_X(rs.getString("CF_DEFECT_X"));
	   	  retPrdIn.setCF_DEFECT_Y(rs.getString("CF_DEFECT_Y"));
	   	  retPrdIn.setCF_POSITION(rs.getString("CF_POSITION"));
	   	  retPrdIn.setLCD_PACK_TIME(rs.getString("LCD_PACK_TIME"));
	   	  retPrdIn.setCF_GLASS_ID(rs.getString("CF_GLASS_ID"));
	   	  retPrdIn.setTFT_POLARIZER(rs.getString("TFT_POLARIZER"));
	   	  retPrdIn.setCF_POLARIZER(rs.getString("CF_POLARIZER"));
	   	  retPrdIn.setGOOD_CUT_COUNT(rs.getInt("GOOD_CUT_COUNT"));
	   	  retPrdIn.setCUT_OX_INFO(rs.getString("CUT_OX_INFO"));
	   	  retPrdIn.setUPDFLAG(rs.getString("UPDFLAG"));
	   	  retPrdIn.setUPDUSER(rs.getString("UPDUSER"));
	   	  retPrdIn.setUPDTIME(rs.getString("UPDTIME"));
	   	  retPrdIn.setINPUT_STATUS(rs.getString("INPUT_STATUS"));
	   	  retPrdIn.setLC_DROPPED(rs.getString("LC_DROPPED"));
	   	  retPrdIn.setABNORMAL_TFT(rs.getString("ABNORMAL_TFT"));
	   	  retPrdIn.setABNORMAL_CF(rs.getString("ABNORMAL_CF"));
	   	  retPrdIn.setABNORMAL_LCD(rs.getString("ABNORMAL_LCD"));
	   	  retPrdIn.setGOOD_CHIP_COUNT(rs.getString("GOOD_CHIP_COUNT"));
	   	  retPrdIn.setTWO_CUTTING_DATE_TIME(rs.getString("TWO_CUTTING_DATE_TIME"));
	   	  retPrdIn.setQ_DATE_TIME(rs.getString("Q_DATE_TIME"));
	   	  retPrdIn.setQ_TIME_RESET_CNT(rs.getString("Q_TIME_RESET_CNT"));
	   	  retPrdIn.setLCD_PRODUCT_ID(rs.getString("LCD_PRODUCT_ID"));
	   	  retPrdIn.setFORMAT_ID(rs.getString("FORMAT_ID"));
	   	  retPrdIn.setRISK_FLAG_CODE(rs.getString("RISK_FLAG_CODE"));
	   	  retPrdIn.setABNORMAL_LCM(rs.getString("ABNORMAL_LCM"));
	   	  retPrdIn.setSERIAL_NO(rs.getString("SERIAL_NO"));
	   	  retPrdIn.setSERIAL_NO_CUST(rs.getString("SERIAL_NO_CUST"));
	   	  retPrdIn.setREVISION(rs.getString("REVISION"));
	   	  retPrdIn.setLCM_CARTON_GRADE(rs.getString("LCM_CARTON_GRADE"));
	   	  retPrdIn.setLCM_GRADE(rs.getString("LCM_GRADE"));
	   	  retPrdIn.setDFCT_LIST(rs.getString("DFCT_LIST"));
	   	  retPrdIn.setWO_CUSTOMER(rs.getString("WO_CUSTOMER"));
	   	  retPrdIn.setFINAL_CUSTOMER(rs.getString("FINAL_CUSTOMER"));
	   	  retPrdIn.setAERB_NO(rs.getString("AERB_NO"));
	   	  retPrdIn.setPI_GROUP_ID(rs.getString("PI_GROUP_ID"));
	   	  retPrdIn.setPE_QTY(rs.getString("PE_QTY"));
	   	  retPrdIn.setSHIPPING_COUNT_TYPE(rs.getString("SHIPPING_COUNT_TYPE"));
	   	  retPrdIn.setGOOD_PNL_COUNT(rs.getString("GOOD_PNL_COUNT"));
	   	  retPrdIn.setITO_FLAG(rs.getString("ITO_FLAG"));
	   	  retPrdIn.setTOD_GRADE(rs.getString("TOD_GRADE"));
	   	  retPrdIn.setCST_ID(rs.getString("CST_ID"));
	   	  retPrdIn.setCST_ZONE_CODE(rs.getString("CST_ZONE_CODE"));
	   	  retPrdIn.setCST_SETTING_CODE(rs.getString("CST_SETTING_CODE"));
	   	  retPrdIn.setTFT_POSITION(rs.getString("TFT_POSITION"));
	   	  retPrdIn.setIN_STOCK_DATE(rs.getString("IN_STOCK_DATE"));
	   	  retPrdIn.setCUT_FLAG(rs.getString("CUT_FLAG"));
	   	  retPrdIn.setSUBSTRATE_POSITION_ID(rs.getString("SUBSTRATE_POSITION_ID"));
	   	  retPrdIn.setCF_SUBSTRATE_POSITION_ID(rs.getString("CF_SUBSTRATE_POSITION_ID"));
	   	  retPrdIn.setCUT_POSITION_ID(rs.getString("CUT_POSITION_ID"));
	   	  retPrdIn.setCUT_CF_POSITION_ID(rs.getString("CUT_CF_POSITION_ID"));
	   	  retPrdIn.setPTT_GRADE(rs.getString("PTT_GRADE"));
	   	  retPrdIn.setTFT_STB_DATE(rs.getString("TFT_STB_DATE"));
	   	  retPrdIn.setTFT_STB_TIME(rs.getString("TFT_STB_TIME"));
	   	  retPrdIn.setLCD_EXP_NO(rs.getString("LCD_EXP_NO"));
	   	  retPrdIn.setLCD_ENG_NAME(rs.getString("LCD_ENG_NAME"));
	   	  retPrdIn.setTFT_ABN_APPLY_TO(rs.getString("TFT_ABN_APPLY_TO"));
	   	  retPrdIn.setCF_ABN_APPLY_TO(rs.getString("CF_ABN_APPLY_TO"));
	   	  retPrdIn.setLCD_ABN_APPLY_TO(rs.getString("LCD_ABN_APPLY_TO"));
	   	  retPrdIn.setCF_STB_DATE(rs.getString("CF_STB_DATE"));
	   	  retPrdIn.setCF_STB_TIME(rs.getString("CF_STB_TIME"));
	   	  retPrdIn.setODF_MOVE_OUT_DATE_TIME(rs.getString("ODF_MOVE_OUT_DATE_TIME"));
	   	  retPrdIn.setCST_ABNORMAL_TFT(rs.getString("CST_ABNORMAL_TFT"));
	   	  retPrdIn.setCST_ABNORMAL_CF(rs.getString("CST_ABNORMAL_CF"));
	   	  retPrdIn.setCST_ABNORMAL_LCD(rs.getString("CST_ABNORMAL_LCD"));
	   	  retPrdIn.setDEFECT_CODE(rs.getString("DEFECT_CODE"));
	   	  retPrdIn.setRESET_2_CUT_DATE_TIME(rs.getString("RESET_2_CUT_DATE_TIME"));
	   	  retPrdIn.setDN_ITEM(rs.getString("DN_ITEM"));
	   	  retPrdIn.setGLASS_WITH_CHIP_ID(rs.getString("GLASS_WITH_CHIP_ID"));
	   	  retPrdIn.setPP_BOX_ID(rs.getString("PP_BOX_ID"));
	   	  retPrdIn.setRISK_LOT_ID(rs.getString("RISK_LOT_ID"));
	   	  retPrdIn.setLC_PART_NO(rs.getString("LC_PART_NO"));
	   	  retPrdIn.setPROCESSED_GLASSID(rs.getString("PROCESSED_GLASSID"));
	   	  retPrdIn.setREF_DELIVERY_NO(rs.getString("REF_DELIVERY_NO"));
	   	  retPrdIn.setEVT_TIMESTAMP(rs.getString("EVT_TIMESTAMP"));
	   	  return retPrdIn;
	 }
	 
}
